0%

Hive Metastore Server发送元数据请求过多被拒绝

在TPCDS测试中Hive莫名其妙挂掉

经查,是MySQL最大连接尝试数设置过低,连接失败10次就无法再连接

在设置的mysql数据库里面,调整次数

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| amon |
| cm |
| hive |
| hue |
| mysql |
| oozie |
| performance_schema |
| test |
+--------------------+
9 rows in set (0.01 sec)

MariaDB [(none)]> show variables like '%max_connect_errors%';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_connect_errors | 10 |
+--------------------+-------+
1 row in set (0.00 sec)

MariaDB [(none)]> set global max_connect_errors = 1000;
Query OK, 0 rows affected (0.02 sec)

MariaDB [(none)]> show variables like '%max_connect_errors%';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_connect_errors | 1000 |
+--------------------+-------+
1 row in set (0.00 sec)

搞定